Re: Error when calling this function.... - Mailing list pgsql-novice

Stuart,

Thanks for the help on the syntax.  My new problem is that now the function seems to be looping endlessly.  No records are being inserted but when I check the 'album_album_id_seq' after stopping the function I see that it's value has been incremented to some really high number.  I've tried stripping the function down to just the first INSERT statement with the same result.  Does the fact that I don't have a WHERE clause in the FOR/SELECT make any difference?

Thanks for any input,

Dan

My new function:

CREATE FUNCTION catalog_batch() RETURNS text AS '

       DECLARE

                mp3rec RECORD;

        BEGIN
           FOR mp3rec IN SELECT * FROM mp3catalog LOOP
            
                INSERT INTO album (title, media, path, release_date) VALUES (mp3catalog.album, mp3catalog.audioformat, mp3catalog.path, mp3catalog.year);
              
                INSERT INTO track (album_id, trk_no, trk_title, time, genre, bitrate, channel, notes) SELECT currval("album_album_id_seq"), mp3catalog.track, mp3catalog.title, mp3catalog.time, mp3catalog.genre, mp3catalog.bitrate, mp3catalog.channels, mp3catalog.comment;
       
                INSERT INTO participant (name) VALUES (mp3catalog.artist);
             
                INSERT INTO performance (album_id, participant_id) SELECT currval("album_album_id_seq"), currval("participant_participant_id_seq");

             END LOOP;
               RETURN Complete;
        END;'
  
        LANGUAGE 'plpgsql';